OpenCities Map CONNECT Edition Help

Importing a PostGres Data Source

PostGres data sources can also be imported with a VRT file. Below is an example of the VRT format for PostGres:

<OGRVRTDataSource>
    <!-- OGR virtual format: http://www.gdal.org/ogr/drv_vrt.html
-->
    <!-- PostgreSQL driver: http://www.gdal.org/ogr/drv_pg.html
-->
 <OGRVRTLayer name="brt_2008_gen">
  <SrcDataSource>PG:dbname=wfs user=user password=pass</SrcDataSource> 
  <SrcLayer>brt_2008_gen</SrcLayer>
  <GeometryType>wkbPolygon</GeometryType> 
        <!-- Do not use GeometryField; doesn't work
with OGR 1.5 -->
  <!--GeometryField encoding="WKB" field="the_geom"/--> 
 </OGRVRTLayer>
</OGRVRTDataSource>